{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Génération","Modèle"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Génération","index":0,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[26,5,26,6],[27,2,27,3],[12,1,12,7],[13,1,13,7],[19,2,19,7],[18,2,18,7],[20,1,20,7]]}
["AMCOORHB",null,null,"Consommation de psychotropes en Ehpad"]
[]
[null,"Nombre de Résidents"]
[]
[]
[]
[]
[]
[]
["MODE D'EMPLOI"]
[]
["Préambule : "]
[null,"Ce petit programme vous permet de générer autant de lignes que de résidents à inclure dans l'étude et fait automatiquement tous les calculs."]
[null,"Il ne faut surtout pas toucher à la feuille Modèle qui sert de base à la macro. Ne rajouter, ni n'enlever aucune ligne ou  ni colonne. Si vous souhaitez faire des modifications, Vous pouvez seulement remplacer un médicament par un autre, à moins que vous ne maitrisiez le VBA...."]
["Pour faire une étude : "]
[null,"Inscrivez le nombre de résidents que vous voulez inclure dans la case rose",null,null,null,null,null,"(E3)"]
[null,"Cliquer sur le bouton \"Générer des lignes\""]
[null,"Une nouvelle feuille se crée appelée Modèle (2) : "]
[null,null,"Vous pouvez la renommer en double cliquant sur l'onglet Modèle(2), inscrire la date du jour par ex."]
[null,null,"Le nombre de lignes souhaitées a été généré et tous les calculs programés pour intégrer toutes les lignes"]
[null,"Chaque fois que vous \"générer des lignes\", vous créez une nouvelle page ( que vous pouvez supprimer bien sûr)"]
["Codage pour remplir les cases",null,null,null,null,"Il faut respecter les majuscules"]
[null,"pour le GIR","A B C "]
[null,"NPI-ES de - 3 mois   ","O","Oui","N","Non"]
[null,"Parkinson ","O","Oui","N","Non"]
[null,"comitialité ","O","Oui","N","Non"]
[null,"clearance de créatinine (moins d'1 an)",">60","<60","N","inconnue ou datant de plus d'un an Ne pas laisser une case vide"]
[null,"Nb chutes depuis 3 mois ","un chiffre",null,0,"Pas de chute"]
[null,"dépression ","O","Oui","N","Non"]
[null,"psychose","P"]
[null,"Alzheimer","A "]
[null,"Corps de Lewy","L",null,null,"laisser vide"]
[null,"Vasculaire","V"]
[null,"Korsakoff","K"]
[null,"Autres démences","D"]
[null,"Pour les médicaments, inscrire 1",null,null,null,"ou laisser vide"]

{"sheet":"Modèle","index":1,"n_rows":41,"n_cols":110,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,85,2,94],[2,27,2,43],[2,12,2,26],[0,60,0,63],[2,0,2,2],[2,3,2,5],[2,49,2,64],[0,11,0,19],[0,47,0,52],[0,27,0,37],[2,65,2,78],[2,79,2,84]]}
["AMCOORHB",null,null,null,"Enquête psychotropes ",null,null,null,null,null,"Etablisement :",null,null,null,null,null,null,null,null,null,"Date du jour de la coupe :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de résidents dans l'étude"]
[null,null,null,null,null,null,null,null,null,null,null,null,"remplir en utilisant le chiffre 1"]
["GIR ABC",null,null,null,null,null,null,null,null,null,null,null,"Anti dépresseurs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Neuroleptiques",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"anticholinestérasiques",null,null,null,null,"autres neurotropes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Benzodiazépines",null,null,null,null,null,null,null,null,null,null,null,null,null,"autres Anxiolytiques",null,null,null,null,null,"Hypnotiques"]
["Cohérence","Orientation","Transferts","NPI-ES de - 3 mois   O/N","Parkinson O/N","comitialité O/N","clearance de créatinine >60, <60, N (moins d'1 an)","Nb chutes depuis 3 mois ","dépréssion O/N","P Psychose,A Alz,L Levy,V Vasc, K Kors, D autres","Nom du Patient","N°","Anafranil","Athymil","Cymbalta","Deroxat","Effexor","Laroxyl","Moclamine","Norset","Prothiaden","Prozac","Seroplex","Seropram","Stablon","Zoloft","TOTAL","Abilify","clopixol","Dipiperon","Dogmatil","Haldol","Leponex","Loxapac","Neuleptil","Nozinan","orap","Risperdal","solian","Tercian","Tiapridal","Zyprexa","TOTAL","Ancienneté des neuroleptiques> 2 mois","Ebixa","Aricept","Reminyl","Exelon","TOTAL","Modopar","Sinemet","Stalevo","Requip","Neurontin","Tegretol","Gardénal","Lyrica","Di Hydan","Lamictal","Keppra","Lioresal","Dantrium","Depakote","Depamide","TOTAL","Lexomil","Lysanxia","myolastan","Nordaz","rivotril","Séresta","Témesta","Tranxène","Urbanyl","Victan","Veratran","Xanax","Valium","TOTAL","Atarax","Buspar","Stresam","Equanil","TOTAL","ancienneté des BZD> 3 mois","Imovane","Stilnox","Havlane","Mogadon","Noctamide","Nuctalon","Normison","Rohypnol","Mepronizine","Noctran","Théralène","TOTAL","Ancienneté des hypnotiques > 1 mois","TOTAL molécules"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dans l'étude :"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"résidents sous 0 psychotrope",null,null,null,null,null,{"$f":"COUNTIF($CU$5:$CU$85,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"résidents sous 1 psychotrope",null,null,null,null,null,{"$f":"COUNTIF($CU$5:$CU$85,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"résidents sous 2 psychotropes",null,null,null,null,null,{"$f":"COUNTIF($CU$5:$CU$85,2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"résidents sous 3 psychotropes",null,null,null,null,null,{"$f":"COUNTIF($CU$5:$CU$85,3)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"résidents sous 4 psychotropes",null,null,null,null,null,{"$f":"COUNTIF($CU$5:$CU$85,4)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"résidents sous 5 psychotropes",null,null,null,null,null,{"$f":"COUNTIF($CU$5:$CU$85,5)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"résidents sous 6 psychotropes",null,null,null,null,null,{"$f":"COUNTIF($CU$5:$CU$85,6)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"résidents sous 7 psychotropes",null,null,null,null,null,{"$f":"COUNTIF($CU$5:$CU$85,7)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nombre de résidents sous ",null,null,null,null,"Antidépresseurs",null,null,null,{"$f":"COUNTIF(AA5:AA85,\">0\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nombre de résidents sous ",null,null,null,null,"Neuroleptiques",null,null,null,{"$f":"COUNTIF(AQ5:AQ85,\">0\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nombre de résidents sous ",null,null,null,null,"anticholinestérasiques",null,null,null,{"$f":"COUNTIF(AW5:AW85,\">0\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nombre de résidents sous ",null,null,null,null,"autres neurotropes",null,null,null,{"$f":"COUNTIF(BM5:BM85,\">0\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nombre de résidents sous ",null,null,null,null,"benzodiazépines",null,null,null,{"$f":"COUNTIF(CA5:CA85,\">0\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nombre de résidents sous ",null,null,null,null,"autres anxiolytiques",null,null,null,{"$f":"COUNTIF(CF5:CF85,\">0\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nombre de résidents sous ",null,null,null,null,"hypnotiques",null,null,null,{"$f":"COUNTIF(CS5:CS85,\">0\")","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nombre de résidents psychotiques connus",null,null,null,null,null,null,null,null,{"$f":"COUNTIF(J5:J85,\"P\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nombre de résidents ayant chuté dans les 3 mois précédents",null,null,null,null,null,null,null,null,{"$f":"COUNTIF(H$6:H$42,\"<>0\")","v":37}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de résidents avec tr cognitifs",null,null,null,null,null,null,null,null,{"$f":"COUNTIF(J$6:J$42,\"A\")+COUNTIF(J$6:J$42,\"L\")+COUNTIF(J$6:J$42,\"V\")+COUNTIF(J$6:J$42,\"K\")+COUNTIF(J$6:J$42,\"D\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de résidents parkinsonniens",null,null,null,null,null,null,null,null,{"$f":"COUNTIF(E$6:E$42,\"O\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de résidents ayant une clearance connue",null,null,null,null,null,null,null,null,{"$f":"COUNTIF(G$5:G$42,\"<>N\")","v":38}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de résidents ayant une dépression",null,null,null,null,null,null,null,null,{"$f":"COUNTIF(I$5:I$42,\"O\")","v":0}]